﻿IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'CreatedOn' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_contentmanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('CreatedOn', 'Créé le', 'fr-ca', 'medianamik_contentmanagement')
ELSE
	UPDATE Localizations SET Value = 'Créé le' WHERE ResourceId = 'CreatedOn' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_contentmanagement'

IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'CreatedOn' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_contentmanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('CreatedOn', 'Created On', 'en-ca', 'medianamik_contentmanagement')
ELSE
	UPDATE Localizations SET Value = 'Created On' WHERE ResourceId = 'CreatedOn' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_contentmanagement'